{ "cells": [ { "cell_type": "markdown", "id": "60e4a74e", "metadata": {}, "source": [ "![token_terminal](https://raw.githubusercontent.com/messari/messari-python-api/feature/demo_notebooks/examples/notebooks/images/tokenterminal_messari_python.PNG)" ] }, { "cell_type": "markdown", "id": "0825c574", "metadata": {}, "source": [ "# Token Terminal Python API Tutorial\n", "\n", "This tutorial aims to be a quick guide to get you started using the Token Terminal API integrated into messari's python library." ] }, { "cell_type": "markdown", "id": "482729a0", "metadata": {}, "source": [ "Token Terminal requires an API key for authentication so the first step before getting started is to create an instance of the TokenTerminal class using your API key." ] }, { "cell_type": "code", "execution_count": 2, "id": "f782c07b", "metadata": {}, "outputs": [], "source": [ "from messari.tokenterminal import TokenTerminal\n", "API_KEY = 'YOUR_API_KEY'\n", "tt = TokenTerminal(api_key=API_KEY)" ] }, { "cell_type": "markdown", "id": "4f23e25c", "metadata": {}, "source": [ "## API Structure\n", "The Messari Python client contains a number of functions that wrap all of Token Terminal's API endpoints. These include:\n", "\n", "* get_project_ids\n", "* get_all_protocol_data\n", "* get_protocol_data\n", "* get_historical_metric_data\n", "\n", "Below are a few examples to showcase the functionality and types of data each function generates" ] }, { "cell_type": "markdown", "id": "7efd3a54", "metadata": {}, "source": [ "## Get project ids" ] }, { "cell_type": "markdown", "id": "cc588f09", "metadata": {}, "source": [ "This function returns all project ids available in Token Terminal. The function is intended to be used as way to find what protocols the API can provide data for." ] }, { "cell_type": "code", "execution_count": 2, "id": "84acbbe1", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "['0x', '1inch', '88mph', 'aave', 'abracadabra-money', 'alchemix-finance', 'alpha-finance', 'autofarm', 'avalanche', 'axie-infinity', 'babyswap', 'balancer', 'bancor', 'barnbridge', 'basket-dao', 'benqi', 'binance-smart-chain', 'bitcoin', 'cardano', 'centrifuge', 'clipper', 'compound', 'cosmos', 'cream', 'cryptex', 'curve', 'decred', 'dhedge', 'dodo', 'dogecoin', 'dydx', 'ellipsis-finance', 'enzyme-finance', 'erasure-protocol', 'ethereum', 'ethereum-name-service', 'fantom', 'fei-protocol', 'filecoin', 'futureswap', 'harvest-finance', 'hegic', 'helium', 'hurricaneswap', 'idle-finance', 'index-cooperative', 'instadapp', 'integral-protocol', 'karura', 'keeperdao', 'keep-network', 'kusama', 'kyber', 'lido-finance', 'liquity', 'litecoin', 'livepeer', 'loopring', 'makerdao', 'maple-finance', 'mcdex', 'metamask', 'mirror-protocol', 'mstable', 'near-protocol', 'nexus-mutual', 'notional-finance', 'opensea', 'optimism', 'pancakeswap', 'pangolin', 'perpetual-protocol', 'piedao', 'polkadot', 'polygon', 'polymarket', 'pooltogether', 'powerpool', 'quickswap', 'rarible', 'rari-capital', 'reflexer', 'ren', 'ribbon-finance', 'saddle-finance', 'set-protocol', 'siren-markets', 'solana', 'spookyswap', 'stake-dao', 'stellar', 'sushiswap', 'swerve-finance', 'synthetix', 'terra', 'tezos', 'the-graph', 'thorchain', 'tokenlon', 'trader-joe', 'uma', 'uniswap', 'unit-protocol', 'venus', 'vesper-finance', 'visor-finance', 'volmex', 'wakaswap', 'xdai', 'yearn-finance', 'yetiswap', 'yield-yak', 'zcash']\n" ] } ], "source": [ "project_ids = tt.get_project_ids()\n", "print(project_ids)" ] }, { "cell_type": "markdown", "id": "118178ac", "metadata": {}, "source": [ "## Get all protocol data" ] }, { "cell_type": "markdown", "id": "0cb3bf11", "metadata": {}, "source": [ "The function returns an overview of the latest data for all projects, ranging from metadata such as launch dates, logos, brand colors and Twitter followers to more fundamental metrics such as Revenue, GMV, TVL and P/S ratios." ] }, { "cell_type": "code", "execution_count": 3, "id": "29af1244", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
0x1inch88mphaaveabracadabra-moneyalchemix-financealpha-financeautofarmavalancheaxie-infinity...venusvesper-financevisor-financevolmexwakaswapxdaiyearn-financeyetiswapyield-yakzcash
name0x1inch88mphAaveAbracadabra.moneyAlchemix FinanceAlpha FinanceAutofarmAvalancheAxie Infinity...VenusVesper FinanceVisor FinanceVolmexWakaSwapxDaiyearn.financeYetiSwapYield YakZcash
symbolZRX1INCHMPHAAVESPELLALCXALPHAAUTOAVAXAXS...XVSVSPVISRWAKASTAKEYFIYTSYAKZEC
launch_date2017-08-152020-12-232019-10-102017-11-252021-05-282021-01-222020-05-102020-04-232020-09-122018-01-26...2020-09-142020-04-222021-01-262021-01-012021-05-012020-06-032020-07-172021-02-012021-02-012016-10-28
category_tagsDeFi,ExchangeDeFi,ExchangeDeFi,LendingDeFi,LendingDeFi,LendingAsset Management,DeFi,Lending,StablecoinDeFi,LendingAsset Management,DeFiBlockchainDeFi,Gaming,NFT...DeFi,Lending,StablecoinAsset Management,DeFiAsset Management,DeFiDeFiDeFi,ExchangeBlockchainAsset Management,DeFiExchangeAsset Management,DeFiBlockchain
description{'how': 'Market makers offer trades through or...{'how': ' Liquidity providers deposit funds in...{'how': 'Lenders deposit funds into 88mph and ...{'how': 'Lenders deposit funds into Aave and r...{'how': 'Overcollateralized borrowers deposit ...{'how': 'Overcollateralized borrowers deposit ...{'how': 'Lenders (Iron Bank) deposit funds int...{'how': 'Liquidity providers deposit funds int...{'how': 'Validators process transactions and r...{'how': 'Players buy/sell NFTs on the Axie mar......{'how': 'Lenders deposit funds into Venus and ...{'how': 'Liquidity providers deposit funds int...{'how': 'Liquidity providers deposit funds int...{'how': 'Liquidity providers deposit collatera...{'how': 'Liquidity providers deposit funds int...{'how': 'Validators process transactions and r...{'how': 'Liquidity providers deposit funds int...{'how': 'Liquidity providers deposit funds int...{'how': 'Users deposit funds into Yield Yak an...{'how': 'Miners process transactions and recei...
..................................................................
revenue_protocol_365d_trend_change9.587743NaNNaN357.351157NaNNaNNaNNaNNaN2223.567062...NaNNaNNaNNaNNaNNaNNaNNaNNaNNaN
volume_24h116407588.145301141814402.258839576299.55105296292692.82865775470966.51694524275380.1674623750808.6674247856976.4073021788215584.085712542065060.549579...29954685.01629881627.605719587411.44606NaNNaNNaN214230966.90826948017.6192361027256.064909413382550.840133
volume_cmgr_300.8814941.1503080.5782480.3367010.4806950.544683-0.1747110.065852-0.316295-0.161278...-0.0850820.4304042.386623NaNNaN0.030908-0.0532741.81919-0.6873950.692857
twitter_followers242374.0398617.013744.0346818.0NaN49868.088468.079119.0NaNNaN...133263.018889.0NaNNaNNaNNaN151785.0NaNNaN81548.0
smart_contract_registry{'available': False}{'available': True, 'url': 'https://raw.github...{'available': False}{'available': True, 'url': 'https://raw.github...{'available': False}{'available': False}{'available': False}{'available': False}{'available': False}{'available': False}...{'available': False}{'available': False}{'available': False}{'available': True, 'url': 'https://raw.github...{'available': False}{'available': False}{'available': False}{'available': False}{'available': True, 'url': 'https://raw.github...{'available': False}
\n", "

181 rows × 113 columns

\n", "
" ], "text/plain": [ " 0x \\\n", "name 0x \n", "symbol ZRX \n", "launch_date 2017-08-15 \n", "category_tags DeFi,Exchange \n", "description {'how': 'Market makers offer trades through or... \n", "... ... \n", "revenue_protocol_365d_trend_change 9.587743 \n", "volume_24h 116407588.145301 \n", "volume_cmgr_30 0.881494 \n", "twitter_followers 242374.0 \n", "smart_contract_registry {'available': False} \n", "\n", " 1inch \\\n", "name 1inch \n", "symbol 1INCH \n", "launch_date 2020-12-23 \n", "category_tags DeFi,Exchange \n", "description {'how': ' Liquidity providers deposit funds in... \n", "... ... \n", "revenue_protocol_365d_trend_change NaN \n", "volume_24h 141814402.258839 \n", "volume_cmgr_30 1.150308 \n", "twitter_followers 398617.0 \n", "smart_contract_registry {'available': True, 'url': 'https://raw.github... \n", "\n", " 88mph \\\n", "name 88mph \n", "symbol MPH \n", "launch_date 2019-10-10 \n", "category_tags DeFi,Lending \n", "description {'how': 'Lenders deposit funds into 88mph and ... \n", "... ... \n", "revenue_protocol_365d_trend_change NaN \n", "volume_24h 576299.55105 \n", "volume_cmgr_30 0.578248 \n", "twitter_followers 13744.0 \n", "smart_contract_registry {'available': False} \n", "\n", " aave \\\n", "name Aave \n", "symbol AAVE \n", "launch_date 2017-11-25 \n", "category_tags DeFi,Lending \n", "description {'how': 'Lenders deposit funds into Aave and r... \n", "... ... \n", "revenue_protocol_365d_trend_change 357.351157 \n", "volume_24h 296292692.828657 \n", "volume_cmgr_30 0.336701 \n", "twitter_followers 346818.0 \n", "smart_contract_registry {'available': True, 'url': 'https://raw.github... \n", "\n", " abracadabra-money \\\n", "name Abracadabra.money \n", "symbol SPELL \n", "launch_date 2021-05-28 \n", "category_tags DeFi,Lending \n", "description {'how': 'Overcollateralized borrowers deposit ... \n", "... ... \n", "revenue_protocol_365d_trend_change NaN \n", "volume_24h 75470966.516945 \n", "volume_cmgr_30 0.480695 \n", "twitter_followers NaN \n", "smart_contract_registry {'available': False} \n", "\n", " alchemix-finance \\\n", "name Alchemix Finance \n", "symbol ALCX \n", "launch_date 2021-01-22 \n", "category_tags Asset Management,DeFi,Lending,Stablecoin \n", "description {'how': 'Overcollateralized borrowers deposit ... \n", "... ... \n", "revenue_protocol_365d_trend_change NaN \n", "volume_24h 24275380.16746 \n", "volume_cmgr_30 0.544683 \n", "twitter_followers 49868.0 \n", "smart_contract_registry {'available': False} \n", "\n", " alpha-finance \\\n", "name Alpha Finance \n", "symbol ALPHA \n", "launch_date 2020-05-10 \n", "category_tags DeFi,Lending \n", "description {'how': 'Lenders (Iron Bank) deposit funds int... \n", "... ... \n", "revenue_protocol_365d_trend_change NaN \n", "volume_24h 23750808.667424 \n", "volume_cmgr_30 -0.174711 \n", "twitter_followers 88468.0 \n", "smart_contract_registry {'available': False} \n", "\n", " autofarm \\\n", "name Autofarm \n", "symbol AUTO \n", "launch_date 2020-04-23 \n", "category_tags Asset Management,DeFi \n", "description {'how': 'Liquidity providers deposit funds int... \n", "... ... \n", "revenue_protocol_365d_trend_change NaN \n", "volume_24h 7856976.407302 \n", "volume_cmgr_30 0.065852 \n", "twitter_followers 79119.0 \n", "smart_contract_registry {'available': False} \n", "\n", " avalanche \\\n", "name Avalanche \n", "symbol AVAX \n", "launch_date 2020-09-12 \n", "category_tags Blockchain \n", "description {'how': 'Validators process transactions and r... \n", "... ... \n", "revenue_protocol_365d_trend_change NaN \n", "volume_24h 1788215584.085712 \n", "volume_cmgr_30 -0.316295 \n", "twitter_followers NaN \n", "smart_contract_registry {'available': False} \n", "\n", " axie-infinity \\\n", "name Axie Infinity \n", "symbol AXS \n", "launch_date 2018-01-26 \n", "category_tags DeFi,Gaming,NFT \n", "description {'how': 'Players buy/sell NFTs on the Axie mar... \n", "... ... \n", "revenue_protocol_365d_trend_change 2223.567062 \n", "volume_24h 542065060.549579 \n", "volume_cmgr_30 -0.161278 \n", "twitter_followers NaN \n", "smart_contract_registry {'available': False} \n", "\n", " ... \\\n", "name ... \n", "symbol ... \n", "launch_date ... \n", "category_tags ... \n", "description ... \n", "... ... \n", "revenue_protocol_365d_trend_change ... \n", "volume_24h ... \n", "volume_cmgr_30 ... \n", "twitter_followers ... \n", "smart_contract_registry ... \n", "\n", " venus \\\n", "name Venus \n", "symbol XVS \n", "launch_date 2020-09-14 \n", "category_tags DeFi,Lending,Stablecoin \n", "description {'how': 'Lenders deposit funds into Venus and ... \n", "... ... \n", "revenue_protocol_365d_trend_change NaN \n", "volume_24h 29954685.01629 \n", "volume_cmgr_30 -0.085082 \n", "twitter_followers 133263.0 \n", "smart_contract_registry {'available': False} \n", "\n", " vesper-finance \\\n", "name Vesper Finance \n", "symbol VSP \n", "launch_date 2020-04-22 \n", "category_tags Asset Management,DeFi \n", "description {'how': 'Liquidity providers deposit funds int... \n", "... ... \n", "revenue_protocol_365d_trend_change NaN \n", "volume_24h 881627.605719 \n", "volume_cmgr_30 0.430404 \n", "twitter_followers 18889.0 \n", "smart_contract_registry {'available': False} \n", "\n", " visor-finance \\\n", "name Visor Finance \n", "symbol VISR \n", "launch_date 2021-01-26 \n", "category_tags Asset Management,DeFi \n", "description {'how': 'Liquidity providers deposit funds int... \n", "... ... \n", "revenue_protocol_365d_trend_change NaN \n", "volume_24h 587411.44606 \n", "volume_cmgr_30 2.386623 \n", "twitter_followers NaN \n", "smart_contract_registry {'available': False} \n", "\n", " volmex \\\n", "name Volmex \n", "symbol \n", "launch_date 2021-01-01 \n", "category_tags DeFi \n", "description {'how': 'Liquidity providers deposit collatera... \n", "... ... \n", "revenue_protocol_365d_trend_change NaN \n", "volume_24h NaN \n", "volume_cmgr_30 NaN \n", "twitter_followers NaN \n", "smart_contract_registry {'available': True, 'url': 'https://raw.github... \n", "\n", " wakaswap \\\n", "name WakaSwap \n", "symbol WAKA \n", "launch_date 2021-05-01 \n", "category_tags DeFi,Exchange \n", "description {'how': 'Liquidity providers deposit funds int... \n", "... ... \n", "revenue_protocol_365d_trend_change NaN \n", "volume_24h NaN \n", "volume_cmgr_30 NaN \n", "twitter_followers NaN \n", "smart_contract_registry {'available': False} \n", "\n", " xdai \\\n", "name xDai \n", "symbol STAKE \n", "launch_date 2020-06-03 \n", "category_tags Blockchain \n", "description {'how': 'Validators process transactions and r... \n", "... ... \n", "revenue_protocol_365d_trend_change NaN \n", "volume_24h NaN \n", "volume_cmgr_30 0.030908 \n", "twitter_followers NaN \n", "smart_contract_registry {'available': False} \n", "\n", " yearn-finance \\\n", "name yearn.finance \n", "symbol YFI \n", "launch_date 2020-07-17 \n", "category_tags Asset Management,DeFi \n", "description {'how': 'Liquidity providers deposit funds int... \n", "... ... \n", "revenue_protocol_365d_trend_change NaN \n", "volume_24h 214230966.908269 \n", "volume_cmgr_30 -0.053274 \n", "twitter_followers 151785.0 \n", "smart_contract_registry {'available': False} \n", "\n", " yetiswap \\\n", "name YetiSwap \n", "symbol YTS \n", "launch_date 2021-02-01 \n", "category_tags Exchange \n", "description {'how': 'Liquidity providers deposit funds int... \n", "... ... \n", "revenue_protocol_365d_trend_change NaN \n", "volume_24h 48017.619236 \n", "volume_cmgr_30 1.81919 \n", "twitter_followers NaN \n", "smart_contract_registry {'available': False} \n", "\n", " yield-yak \\\n", "name Yield Yak \n", "symbol YAK \n", "launch_date 2021-02-01 \n", "category_tags Asset Management,DeFi \n", "description {'how': 'Users deposit funds into Yield Yak an... \n", "... ... \n", "revenue_protocol_365d_trend_change NaN \n", "volume_24h 1027256.064909 \n", "volume_cmgr_30 -0.687395 \n", "twitter_followers NaN \n", "smart_contract_registry {'available': True, 'url': 'https://raw.github... \n", "\n", " zcash \n", "name Zcash \n", "symbol ZEC \n", "launch_date 2016-10-28 \n", "category_tags Blockchain \n", "description {'how': 'Miners process transactions and recei... \n", "... ... \n", "revenue_protocol_365d_trend_change NaN \n", "volume_24h 413382550.840133 \n", "volume_cmgr_30 0.692857 \n", "twitter_followers 81548.0 \n", "smart_contract_registry {'available': False} \n", "\n", "[181 rows x 113 columns]" ] }, "execution_count": 3, "metadata": {}, "output_type": "execute_result" } ], "source": [ "all_protocol_data = tt.get_all_protocol_data()\n", "all_protocol_data" ] }, { "cell_type": "markdown", "id": "ee6b1988", "metadata": {}, "source": [ "## Get protocol data" ] }, { "cell_type": "markdown", "id": "a020cf76", "metadata": {}, "source": [ "The function returns a time series of the latest data for a given project, ranging from metadata such as Twitter followers to more fundamental metrics such as Revenue, GMV, TVL and P/S ratios." ] }, { "cell_type": "code", "execution_count": 6, "id": "091f802f", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
uniswap
projectbusiness_typebusiness_lineversionchaincomponentpricemarket_capmarket_cap_circulatingmarket_cap_fully_diluted...pepe_circulatingpsps_circulatingtvlgmvrevenuerevenue_supply_siderevenue_protocoltoken_incentives
2021-10-01UniswaptotaltotaltotaltotalNone23.4441922.344419e+101.216002e+102.344419e+10...NoneNone15.3407307.9569224.562549e+091.672296e+093.229105e+063.229105e+060.0None
2021-10-02UniswaptotaltotaltotaltotalNone25.6492862.564929e+101.327781e+102.564929e+10...NoneNone16.9938748.7971794.643719e+091.257296e+092.786595e+062.786595e+060.0None
2021-10-03UniswaptotaltotaltotaltotalNone25.6492862.564929e+101.327781e+102.564929e+10...NoneNone17.1888048.8980874.648515e+091.221896e+092.624770e+062.624770e+060.0None
2021-10-04UniswaptotaltotaltotaltotalNone26.0446802.604468e+101.354416e+102.604468e+10...NoneNone17.8528469.2841124.613903e+091.570555e+093.464031e+063.464031e+060.0None
2021-10-05UniswaptotaltotaltotaltotalNone25.3019832.530198e+101.318691e+102.530198e+10...NoneNone17.4982649.1197644.754376e+091.413950e+093.553829e+063.553829e+060.0None
2021-10-06UniswaptotaltotaltotaltotalNone25.6813842.568138e+101.337438e+102.568138e+10...NoneNone17.7753819.2570804.774576e+091.943523e+094.138442e+064.138442e+060.0None
2021-10-07UniswaptotaltotaltotaltotalNone25.3206472.532065e+101.316125e+102.532065e+10...NoneNone17.4827949.0872684.774576e+091.929270e+095.215952e+065.215952e+060.0None
2021-10-08UniswaptotaltotaltotaltotalNone25.5897632.558976e+101.329077e+102.558976e+10...NoneNone18.2797959.4941294.760272e+091.447673e+093.800945e+063.800945e+060.0None
2021-10-09UniswaptotaltotaltotaltotalNone24.7166862.471669e+101.287703e+102.471669e+10...NoneNone18.1815299.4723094.874226e+091.035189e+092.963146e+062.963146e+060.0None
2021-10-10UniswaptotaltotaltotaltotalNone25.1889472.518895e+101.311264e+102.518895e+10...NoneNone18.7128649.7413784.788339e+091.480371e+093.324778e+063.324778e+060.0None
\n", "

10 rows × 22 columns

\n", "
" ], "text/plain": [ " uniswap \\\n", " project business_type business_line version chain component \n", "2021-10-01 Uniswap total total total total None \n", "2021-10-02 Uniswap total total total total None \n", "2021-10-03 Uniswap total total total total None \n", "2021-10-04 Uniswap total total total total None \n", "2021-10-05 Uniswap total total total total None \n", "2021-10-06 Uniswap total total total total None \n", "2021-10-07 Uniswap total total total total None \n", "2021-10-08 Uniswap total total total total None \n", "2021-10-09 Uniswap total total total total None \n", "2021-10-10 Uniswap total total total total None \n", "\n", " \\\n", " price market_cap market_cap_circulating \n", "2021-10-01 23.444192 2.344419e+10 1.216002e+10 \n", "2021-10-02 25.649286 2.564929e+10 1.327781e+10 \n", "2021-10-03 25.649286 2.564929e+10 1.327781e+10 \n", "2021-10-04 26.044680 2.604468e+10 1.354416e+10 \n", "2021-10-05 25.301983 2.530198e+10 1.318691e+10 \n", "2021-10-06 25.681384 2.568138e+10 1.337438e+10 \n", "2021-10-07 25.320647 2.532065e+10 1.316125e+10 \n", "2021-10-08 25.589763 2.558976e+10 1.329077e+10 \n", "2021-10-09 24.716686 2.471669e+10 1.287703e+10 \n", "2021-10-10 25.188947 2.518895e+10 1.311264e+10 \n", "\n", " ... \\\n", " market_cap_fully_diluted ... pe pe_circulating ps \n", "2021-10-01 2.344419e+10 ... None None 15.340730 \n", "2021-10-02 2.564929e+10 ... None None 16.993874 \n", "2021-10-03 2.564929e+10 ... None None 17.188804 \n", "2021-10-04 2.604468e+10 ... None None 17.852846 \n", "2021-10-05 2.530198e+10 ... None None 17.498264 \n", "2021-10-06 2.568138e+10 ... None None 17.775381 \n", "2021-10-07 2.532065e+10 ... None None 17.482794 \n", "2021-10-08 2.558976e+10 ... None None 18.279795 \n", "2021-10-09 2.471669e+10 ... None None 18.181529 \n", "2021-10-10 2.518895e+10 ... None None 18.712864 \n", "\n", " \\\n", " ps_circulating tvl gmv revenue \n", "2021-10-01 7.956922 4.562549e+09 1.672296e+09 3.229105e+06 \n", "2021-10-02 8.797179 4.643719e+09 1.257296e+09 2.786595e+06 \n", "2021-10-03 8.898087 4.648515e+09 1.221896e+09 2.624770e+06 \n", "2021-10-04 9.284112 4.613903e+09 1.570555e+09 3.464031e+06 \n", "2021-10-05 9.119764 4.754376e+09 1.413950e+09 3.553829e+06 \n", "2021-10-06 9.257080 4.774576e+09 1.943523e+09 4.138442e+06 \n", "2021-10-07 9.087268 4.774576e+09 1.929270e+09 5.215952e+06 \n", "2021-10-08 9.494129 4.760272e+09 1.447673e+09 3.800945e+06 \n", "2021-10-09 9.472309 4.874226e+09 1.035189e+09 2.963146e+06 \n", "2021-10-10 9.741378 4.788339e+09 1.480371e+09 3.324778e+06 \n", "\n", " \n", " revenue_supply_side revenue_protocol token_incentives \n", "2021-10-01 3.229105e+06 0.0 None \n", "2021-10-02 2.786595e+06 0.0 None \n", "2021-10-03 2.624770e+06 0.0 None \n", "2021-10-04 3.464031e+06 0.0 None \n", "2021-10-05 3.553829e+06 0.0 None \n", "2021-10-06 4.138442e+06 0.0 None \n", "2021-10-07 5.215952e+06 0.0 None \n", "2021-10-08 3.800945e+06 0.0 None \n", "2021-10-09 2.963146e+06 0.0 None \n", "2021-10-10 3.324778e+06 0.0 None \n", "\n", "[10 rows x 22 columns]" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "protocols = ['uniswap']\n", "start_date = \"2021-10-01\"\n", "end_date = \"2021-10-10\"\n", "protocol_data = tt.get_protocol_data(protocols, start_date=start_date, end_date=end_date)\n", "protocol_data" ] }, { "cell_type": "markdown", "id": "1cbe98c4", "metadata": {}, "source": [ "You can also pass a list of protocols as follows:" ] }, { "cell_type": "code", "execution_count": 8, "id": "a8ca7f76", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
uniswap...compound
projectbusiness_typebusiness_lineversionchaincomponentpricemarket_capmarket_cap_circulatingmarket_cap_fully_diluted...pepe_circulatingpsps_circulatingtvlgmvrevenuerevenue_supply_siderevenue_protocoltoken_incentives
2021-10-01UniswaptotaltotaltotaltotalNone23.4441922.344419e+101.216002e+102.344419e+10...72.37097542.5998947.9925814.7046911.031562e+105.589713e+09956431.991425859716.30511496715.6863110.0
2021-10-02UniswaptotaltotaltotaltotalNone25.6492862.564929e+101.327781e+102.564929e+10...76.02201944.7139798.3692794.9225711.044957e+105.593048e+09935131.217816839693.56209095437.6557260.0
2021-10-03UniswaptotaltotaltotaltotalNone25.6492862.564929e+101.327781e+102.564929e+10...79.55427346.8460318.7488375.1518081.020987e+105.620313e+09818289.770154731997.30753186292.4626230.0
2021-10-04UniswaptotaltotaltotaltotalNone26.0446802.604468e+101.354416e+102.604468e+10...80.69615747.4712278.8782145.2227981.020987e+105.595316e+09802641.065305717303.13106385337.9342420.0
2021-10-05UniswaptotaltotaltotaltotalNone25.3019832.530198e+101.318691e+102.530198e+10...75.88650746.2414918.3497515.0879261.032968e+105.558912e+09787867.672436704276.01293883591.6594980.0
2021-10-06UniswaptotaltotaltotaltotalNone25.6813842.568138e+101.337438e+102.568138e+10...76.13656846.3583308.3608925.0908129.899078e+095.373649e+09862805.591801774315.22253788490.3692640.0
2021-10-07UniswaptotaltotaltotaltotalNone25.3206472.532065e+101.316125e+102.532065e+10...76.42463146.4966898.3899295.1044279.899078e+095.485177e+09887401.478753796357.99656691043.4821870.0
2021-10-08UniswaptotaltotaltotaltotalNone25.5897632.558976e+101.329077e+102.558976e+10...80.04297648.6681648.7943535.3471901.058897e+105.493907e+09839121.611572750479.91781688641.6937560.0
2021-10-09UniswaptotaltotaltotaltotalNone24.7166862.471669e+101.287703e+102.471669e+10...80.56668348.8719868.8432685.3643521.045710e+105.376628e+09712359.128314634413.77003077945.3582840.0
2021-10-10UniswaptotaltotaltotaltotalNone25.1889472.518895e+101.311264e+102.518895e+10...86.07013652.3870659.4351115.7427331.020492e+105.410650e+09703203.795413625171.00553778032.7898760.0
\n", "

10 rows × 44 columns

\n", "
" ], "text/plain": [ " uniswap \\\n", " project business_type business_line version chain component \n", "2021-10-01 Uniswap total total total total None \n", "2021-10-02 Uniswap total total total total None \n", "2021-10-03 Uniswap total total total total None \n", "2021-10-04 Uniswap total total total total None \n", "2021-10-05 Uniswap total total total total None \n", "2021-10-06 Uniswap total total total total None \n", "2021-10-07 Uniswap total total total total None \n", "2021-10-08 Uniswap total total total total None \n", "2021-10-09 Uniswap total total total total None \n", "2021-10-10 Uniswap total total total total None \n", "\n", " \\\n", " price market_cap market_cap_circulating \n", "2021-10-01 23.444192 2.344419e+10 1.216002e+10 \n", "2021-10-02 25.649286 2.564929e+10 1.327781e+10 \n", "2021-10-03 25.649286 2.564929e+10 1.327781e+10 \n", "2021-10-04 26.044680 2.604468e+10 1.354416e+10 \n", "2021-10-05 25.301983 2.530198e+10 1.318691e+10 \n", "2021-10-06 25.681384 2.568138e+10 1.337438e+10 \n", "2021-10-07 25.320647 2.532065e+10 1.316125e+10 \n", "2021-10-08 25.589763 2.558976e+10 1.329077e+10 \n", "2021-10-09 24.716686 2.471669e+10 1.287703e+10 \n", "2021-10-10 25.188947 2.518895e+10 1.311264e+10 \n", "\n", " ... compound \\\n", " market_cap_fully_diluted ... pe pe_circulating ps \n", "2021-10-01 2.344419e+10 ... 72.370975 42.599894 7.992581 \n", "2021-10-02 2.564929e+10 ... 76.022019 44.713979 8.369279 \n", "2021-10-03 2.564929e+10 ... 79.554273 46.846031 8.748837 \n", "2021-10-04 2.604468e+10 ... 80.696157 47.471227 8.878214 \n", "2021-10-05 2.530198e+10 ... 75.886507 46.241491 8.349751 \n", "2021-10-06 2.568138e+10 ... 76.136568 46.358330 8.360892 \n", "2021-10-07 2.532065e+10 ... 76.424631 46.496689 8.389929 \n", "2021-10-08 2.558976e+10 ... 80.042976 48.668164 8.794353 \n", "2021-10-09 2.471669e+10 ... 80.566683 48.871986 8.843268 \n", "2021-10-10 2.518895e+10 ... 86.070136 52.387065 9.435111 \n", "\n", " \\\n", " ps_circulating tvl gmv revenue \n", "2021-10-01 4.704691 1.031562e+10 5.589713e+09 956431.991425 \n", "2021-10-02 4.922571 1.044957e+10 5.593048e+09 935131.217816 \n", "2021-10-03 5.151808 1.020987e+10 5.620313e+09 818289.770154 \n", "2021-10-04 5.222798 1.020987e+10 5.595316e+09 802641.065305 \n", "2021-10-05 5.087926 1.032968e+10 5.558912e+09 787867.672436 \n", "2021-10-06 5.090812 9.899078e+09 5.373649e+09 862805.591801 \n", "2021-10-07 5.104427 9.899078e+09 5.485177e+09 887401.478753 \n", "2021-10-08 5.347190 1.058897e+10 5.493907e+09 839121.611572 \n", "2021-10-09 5.364352 1.045710e+10 5.376628e+09 712359.128314 \n", "2021-10-10 5.742733 1.020492e+10 5.410650e+09 703203.795413 \n", "\n", " \n", " revenue_supply_side revenue_protocol token_incentives \n", "2021-10-01 859716.305114 96715.686311 0.0 \n", "2021-10-02 839693.562090 95437.655726 0.0 \n", "2021-10-03 731997.307531 86292.462623 0.0 \n", "2021-10-04 717303.131063 85337.934242 0.0 \n", "2021-10-05 704276.012938 83591.659498 0.0 \n", "2021-10-06 774315.222537 88490.369264 0.0 \n", "2021-10-07 796357.996566 91043.482187 0.0 \n", "2021-10-08 750479.917816 88641.693756 0.0 \n", "2021-10-09 634413.770030 77945.358284 0.0 \n", "2021-10-10 625171.005537 78032.789876 0.0 \n", "\n", "[10 rows x 44 columns]" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "protocols = ['uniswap', 'compound']\n", "protocols_data = tt.get_protocol_data(protocols, start_date=start_date, end_date=end_date)\n", "protocols_data" ] }, { "cell_type": "markdown", "id": "afa315f1", "metadata": {}, "source": [ "Now you can access data for both Uniswap or Compound by indexing based on the protocol of interest" ] }, { "cell_type": "code", "execution_count": 14, "id": "3afa1cce", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
projectbusiness_typebusiness_lineversionchaincomponentpricemarket_capmarket_cap_circulatingmarket_cap_fully_diluted...pepe_circulatingpsps_circulatingtvlgmvrevenuerevenue_supply_siderevenue_protocoltoken_incentives
2021-10-01CompoundtotaltotaltotaltotalNone312.1323003.121323e+091.837312e+093.121323e+09...72.37097542.5998947.9925814.7046911.031562e+105.589713e+09956431.991425859716.30511496715.6863110.0
2021-10-02CompoundtotaltotaltotaltotalNone326.3602903.263603e+091.919558e+093.263603e+09...76.02201944.7139798.3692794.9225711.044957e+105.593048e+09935131.217816839693.56209095437.6557260.0
2021-10-03CompoundtotaltotaltotaltotalNone338.1391693.381392e+091.991154e+093.381392e+09...79.55427346.8460318.7488375.1518081.020987e+105.620313e+09818289.770154731997.30753186292.4626230.0
2021-10-04CompoundtotaltotaltotaltotalNone338.1391693.381392e+091.989175e+093.381392e+09...80.69615747.4712278.8782145.2227981.020987e+105.595316e+09802641.065305717303.13106385337.9342420.0
2021-10-05CompoundtotaltotaltotaltotalNone313.2186273.132186e+091.908600e+093.132186e+09...75.88650746.2414918.3497515.0879261.032968e+105.558912e+09787867.672436704276.01293883591.6594980.0
2021-10-06CompoundtotaltotaltotaltotalNone310.4928583.104929e+091.890541e+093.104929e+09...76.13656846.3583308.3608925.0908129.899078e+095.373649e+09862805.591801774315.22253788490.3692640.0
2021-10-07CompoundtotaltotaltotaltotalNone307.0385373.070385e+091.868020e+093.070385e+09...76.42463146.4966898.3899295.1044279.899078e+095.485177e+09887401.478753796357.99656691043.4821870.0
2021-10-08CompoundtotaltotaltotaltotalNone315.9852633.159853e+091.921271e+093.159853e+09...80.04297648.6681648.7943535.3471901.058897e+105.493907e+09839121.611572750479.91781688641.6937560.0
2021-10-09CompoundtotaltotaltotaltotalNone313.5638703.135639e+091.902088e+093.135639e+09...80.56668348.8719868.8432685.3643521.045710e+105.376628e+09712359.128314634413.77003077945.3582840.0
2021-10-10CompoundtotaltotaltotaltotalNone331.0757373.310757e+092.015111e+093.310757e+09...86.07013652.3870659.4351115.7427331.020492e+105.410650e+09703203.795413625171.00553778032.7898760.0
\n", "

10 rows × 22 columns

\n", "
" ], "text/plain": [ " project business_type business_line version chain component \\\n", "2021-10-01 Compound total total total total None \n", "2021-10-02 Compound total total total total None \n", "2021-10-03 Compound total total total total None \n", "2021-10-04 Compound total total total total None \n", "2021-10-05 Compound total total total total None \n", "2021-10-06 Compound total total total total None \n", "2021-10-07 Compound total total total total None \n", "2021-10-08 Compound total total total total None \n", "2021-10-09 Compound total total total total None \n", "2021-10-10 Compound total total total total None \n", "\n", " price market_cap market_cap_circulating \\\n", "2021-10-01 312.132300 3.121323e+09 1.837312e+09 \n", "2021-10-02 326.360290 3.263603e+09 1.919558e+09 \n", "2021-10-03 338.139169 3.381392e+09 1.991154e+09 \n", "2021-10-04 338.139169 3.381392e+09 1.989175e+09 \n", "2021-10-05 313.218627 3.132186e+09 1.908600e+09 \n", "2021-10-06 310.492858 3.104929e+09 1.890541e+09 \n", "2021-10-07 307.038537 3.070385e+09 1.868020e+09 \n", "2021-10-08 315.985263 3.159853e+09 1.921271e+09 \n", "2021-10-09 313.563870 3.135639e+09 1.902088e+09 \n", "2021-10-10 331.075737 3.310757e+09 2.015111e+09 \n", "\n", " market_cap_fully_diluted ... pe pe_circulating \\\n", "2021-10-01 3.121323e+09 ... 72.370975 42.599894 \n", "2021-10-02 3.263603e+09 ... 76.022019 44.713979 \n", "2021-10-03 3.381392e+09 ... 79.554273 46.846031 \n", "2021-10-04 3.381392e+09 ... 80.696157 47.471227 \n", "2021-10-05 3.132186e+09 ... 75.886507 46.241491 \n", "2021-10-06 3.104929e+09 ... 76.136568 46.358330 \n", "2021-10-07 3.070385e+09 ... 76.424631 46.496689 \n", "2021-10-08 3.159853e+09 ... 80.042976 48.668164 \n", "2021-10-09 3.135639e+09 ... 80.566683 48.871986 \n", "2021-10-10 3.310757e+09 ... 86.070136 52.387065 \n", "\n", " ps ps_circulating tvl gmv \\\n", "2021-10-01 7.992581 4.704691 1.031562e+10 5.589713e+09 \n", "2021-10-02 8.369279 4.922571 1.044957e+10 5.593048e+09 \n", "2021-10-03 8.748837 5.151808 1.020987e+10 5.620313e+09 \n", "2021-10-04 8.878214 5.222798 1.020987e+10 5.595316e+09 \n", "2021-10-05 8.349751 5.087926 1.032968e+10 5.558912e+09 \n", "2021-10-06 8.360892 5.090812 9.899078e+09 5.373649e+09 \n", "2021-10-07 8.389929 5.104427 9.899078e+09 5.485177e+09 \n", "2021-10-08 8.794353 5.347190 1.058897e+10 5.493907e+09 \n", "2021-10-09 8.843268 5.364352 1.045710e+10 5.376628e+09 \n", "2021-10-10 9.435111 5.742733 1.020492e+10 5.410650e+09 \n", "\n", " revenue revenue_supply_side revenue_protocol \\\n", "2021-10-01 956431.991425 859716.305114 96715.686311 \n", "2021-10-02 935131.217816 839693.562090 95437.655726 \n", "2021-10-03 818289.770154 731997.307531 86292.462623 \n", "2021-10-04 802641.065305 717303.131063 85337.934242 \n", "2021-10-05 787867.672436 704276.012938 83591.659498 \n", "2021-10-06 862805.591801 774315.222537 88490.369264 \n", "2021-10-07 887401.478753 796357.996566 91043.482187 \n", "2021-10-08 839121.611572 750479.917816 88641.693756 \n", "2021-10-09 712359.128314 634413.770030 77945.358284 \n", "2021-10-10 703203.795413 625171.005537 78032.789876 \n", "\n", " token_incentives \n", "2021-10-01 0.0 \n", "2021-10-02 0.0 \n", "2021-10-03 0.0 \n", "2021-10-04 0.0 \n", "2021-10-05 0.0 \n", "2021-10-06 0.0 \n", "2021-10-07 0.0 \n", "2021-10-08 0.0 \n", "2021-10-09 0.0 \n", "2021-10-10 0.0 \n", "\n", "[10 rows x 22 columns]" ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "protocols_data['compound']" ] }, { "cell_type": "markdown", "id": "d69d03ed", "metadata": {}, "source": [ "## Get historical metric data" ] }, { "cell_type": "markdown", "id": "c2258508", "metadata": {}, "source": [ "This function returns the time series of a specified metric for a given list of projects.\n", "\n", "Available metrics include: \n", "- price\n", "- market_cap\n", "- market_cap_circulating\n", "- market_cap_fully_diluted\n", "- volume\n", "- vol_mc\n", "- pe\n", "- ps\n", "- tvl\n", "- gmv\n", "- revenue\n", "- revenue_supply_side\n", "- revenue_protocol\n", "- token_incentives" ] }, { "cell_type": "code", "execution_count": 15, "id": "af1356e4", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
uniswapcompound
2021-10-012.344419e+103.121323e+09
2021-10-022.564929e+103.263603e+09
2021-10-032.564929e+103.381392e+09
2021-10-042.604468e+103.381392e+09
2021-10-052.530198e+103.132186e+09
2021-10-062.568138e+103.104929e+09
2021-10-072.532065e+103.070385e+09
2021-10-082.558976e+103.159853e+09
2021-10-092.471669e+103.135639e+09
2021-10-102.518895e+103.310757e+09
\n", "
" ], "text/plain": [ " uniswap compound\n", "2021-10-01 2.344419e+10 3.121323e+09\n", "2021-10-02 2.564929e+10 3.263603e+09\n", "2021-10-03 2.564929e+10 3.381392e+09\n", "2021-10-04 2.604468e+10 3.381392e+09\n", "2021-10-05 2.530198e+10 3.132186e+09\n", "2021-10-06 2.568138e+10 3.104929e+09\n", "2021-10-07 2.532065e+10 3.070385e+09\n", "2021-10-08 2.558976e+10 3.159853e+09\n", "2021-10-09 2.471669e+10 3.135639e+09\n", "2021-10-10 2.518895e+10 3.310757e+09" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "metric = \"market_cap\"\n", "historical_mktcap = tt.get_historical_metric_data(protocols, metric=metric,\n", " start_date=start_date, end_date=end_date)\n", "historical_mktcap" ] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.9.6" } }, "nbformat": 4, "nbformat_minor": 5 }